Diagram UHCContracts_4

Defincja diagramu UHCContracts_4

Name

UHCContracts_4

Code

UHCContracts_4

Comment

 


Lista tabel diagramu

Name

Code

AccountData

AccountData

AdmissionMode

AdmissionMode

AssessmentOfDisorder

AssessmentOfDisorder

Contractor

Contractor

DischargeMode

DischargeMode

Episode

Episode

Event

Event

EventSession

EventSession

EventWaitingList

EventWaitingList

ICD

ICD

IssueReferral

IssueReferral

OrgUnit

OrgUnit

PersonnelType

PersonnelType

Referral

Referral

ReferralOrgUnit

ReferralOrgUnit

SuggestionDRGGroup

SuggestionDRGGroup

WLProcedure

WLProcedure


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_77

R_77

DischargeMode

Episode

DischargeModeID

 

 

R_78

R_78

AdmissionMode

Episode

AdmissionModeID

 

 

R_95

R_95

Referral

Episode

ReferralID

 

 

R_97

R_97

WLProcedure

EventWaitingList

WLProcedureID

 

 

R_98

R_98

EventWaitingList

Event

WaitingListID

 

 

R_141

R_141

EventSession

Event

EventSessionID

 

 

R_142

R_142

ICD

IssueReferral

ICDID

 

 

R_143

R_143

PersonnelType

IssueReferral

PersonnelTypeID

 

 

R_210

R_210

Event

SuggestionDRGGroup

EventID

 

 

R_211

R_211

Episode

SuggestionDRGGroup

EpisodeID

 

 

R_212

R_212

AccountData

SuggestionDRGGroup

AccountDataID

 

 

R_320

R_320

ICD

Referral

ICDID

 

 

R_321

R_321

Contractor

Referral

ContractorID

 

 

R_410

R_410

Episode

AssessmentOfDisorder

EpisodeID

 

 

R_629

R_629

ICD

Episode

InfectionICDID